﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.ComponentModel.DataAnnotations;
using BenefitHelper.Sys;
namespace BenefitHelper.Data.Day
{
    /// <summary>
    /// 单日账户交易合约(那些小计的合约信息也直接在这里面写入)当Account为-1时为总数
    /// </summary>
    public class AccountDayTradeInstrument
    {
        [Key]
        public int Id { get; set; }
        /// <summary>
        /// 操作账户
        /// </summary>
        public int AccountId { get; set; }
        /// <summary>
        /// 操作账户
        /// </summary>
        public virtual Account Account { get; set; }
        /// <summary>
        /// 交易日
        /// </summary>
        public int TradeHistoryId { get; set; }
        /// <summary>
        /// 交易日
        /// </summary>
        public virtual TradeHistory TradeHistory { get; set; }
        /// <summary>
        /// 交易合约
        /// </summary>
        public int InstrumentId { get; set; }
        /// <summary>
        /// 交易合约
        /// </summary>
        public virtual Instrument Instrument { get; set; }
        /// <summary>
        /// 多空方向
        /// </summary>
        public int Direction { get; set; }

        /// <summary>
        /// 平仓盈亏
        /// </summary>
        public double Profit { get; set; }
        /// <summary>
        /// 手续费
        /// </summary>
        public double Free { get; set; }
        /// <summary>
        /// 净收益
        /// </summary>
        public double DayCount { get; set; }
        /// <summary>
        /// 交易笔数
        /// </summary>
        public double BillCount { get; set; }
        /// <summary>
        /// 总亏损
        /// </summary>
        public double SumLost { get; set; }
        /// <summary>
        /// 总盈利
        /// </summary>
        public double SumWin { get; set; }
        /// <summary>
        /// 保证金占用
        /// </summary>
        public double UsedMargin { get; set; }
        /// <summary>
        /// 盈利次数
        /// </summary>
        public int WinCount { get; set; }
        /// <summary>
        /// 亏损次数
        /// </summary>
        public int LoseCount { get; set; }

        /// <summary>
        /// 删除当日所有记录
        /// </summary>
        /// <param name="tradeHistoryId"></param>
        public void Delete(int tradeHistoryId, DB.DBManager db)
        {
            var query = from t in db.AccountDayTradeInstrument where t.TradeHistoryId == tradeHistoryId select t;
            foreach (Data.Day.AccountDayTradeInstrument c in query)
            {
                db.AccountDayTradeInstrument.Remove(c);
            }
            db.SaveChanges();
        }


        /// <summary>
        /// 保存账号日变化情况
        /// </summary>
        /// <param name="tradeHistoryId">插入时间编号</param>
        /// <param name="pdate">插入时间</param>
        public void InitDayAccountInstrumentChange(int tradeHistoryId, string pdate, DB.DBManager db)
        {
            List<Data.ServerData.T_Account> serverAccounts = new List<ServerData.T_Account>();
            int connectionStringCount = System.Configuration.ConfigurationManager.ConnectionStrings.Count;
            for (int i = 0; i < connectionStringCount; i++)
            {
                string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings[i].ConnectionString;
                if (System.Configuration.ConfigurationManager.ConnectionStrings[i].ProviderName.Equals("System.Data.OracleClient"))
                {
                    Common.ADO.Tools.OracleHelper.connectionString = connectionString;
                    List<BenefitHelper.Data.ServerData.T_Account> accountList = new BenefitHelper.Data.ServerData.T_Account().GetList();
                    foreach (BenefitHelper.Data.ServerData.T_Account _account in accountList)
                    {
                        serverAccounts.Add(_account);
                    }
                }
            }
            BenefitHelper.Sys.TradeHistory th = new TradeHistory();
            foreach (Data.ServerData.T_Account account in serverAccounts)
            {
                Data.ServerData.T_TradeDetail_History tth = new Data.ServerData.T_TradeDetail_History();
                List<string> instruments = tth.GetAccountDayInstrument(pdate, account.Id);
                foreach (string instrument in instruments)
                {
                    #region i为0是多，i为1是空
                    for (int i = 0; i < 2; i++)
                    {
                        Data.Day.AccountDayTradeInstrument change = new Data.Day.AccountDayTradeInstrument();
                        Sys.Account _account = new Sys.Account();
                        change.AccountId = _account.GetAccountId(account.LoginAccount);
                        change.TradeHistoryId = tradeHistoryId;
                        change.Direction = i;
                        change.BillCount = tth.GetDayInstrumentBillCount(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.Free = tth.GetDayInstrumentCommission(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.InstrumentId = new Sys.Instrument().GetInstrumentId(instrument, db);
                        change.LoseCount = tth.GetDayInstrumentLoseCount(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.Profit = tth.GetDayInstrumentCloseProfit(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.DayCount = change.Profit - change.Free;
                        change.SumLost = tth.GetDayInstrumentAllLose(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.SumWin = tth.GetDayInstrumentAllWin(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        change.UsedMargin = new BenefitHelper.Data.ServerData.T_PositionDetail_History().GetAccountInstrument(account.Id, th.GetPdateFromSettlementId(tradeHistoryId, db), instrument, db);
                        change.WinCount = tth.GetDayInstrumentWinCount(pdate, account.Id, instrument, change.Direction.ToString(), db);
                        db.AccountDayTradeInstrument.Add(change);
                    }
                    #endregion
                }
            }
            db.SaveChanges();
        }


        public List<AccountDayTradeInstrument> GetAccountDayTradeInstruments(int accountid, int tradeHistoryId, DB.DBManager db)
        {
            List<AccountDayTradeInstrument> instruments = new List<AccountDayTradeInstrument>();
            var query = db.AccountDayTradeInstrument.Where(a => a.AccountId == accountid).Where(a => a.TradeHistoryId == tradeHistoryId);
            if (query.Count() > 0)
            {
                instruments = query.ToList();
            }
            return instruments;
        }
    }
}